package com.chixing.entity;

import java.time.LocalDateTime;

public class ApplicationVO {
    //select a.application_id,c.candidate_id,c.candidate_name,com.company_id,com.company_name,
    //j.job_id,j.job_title,j.job_description,j.job_salary_min,j.job_salary_max,
    //a.applied_at,a.cover_letter,a.application_status
    //from candidate c join application a
    //on c.candidate_id = a.candidate_id
    //join job j
    //on a.job_id = j.job_id
    //join company com
    //on com.company_id = j.job_company_id
    //where c.candidate_id = 1
    private int applicationId;
    private int candidateId;
    private String candidateName;
    private int companyId;
    private String companyName;
    private int jobId;
    private String jobTitle;
    private String jobDescription;
    private float jobSalaryMin;
    private float jobSalaryMax;
    private LocalDateTime appliedAt;
    private String coverLetter;
    private String applicationStatus;
}
